Page Control Search – Dynamics 365 BC Table Reference

SELECT p.ID ,p.Name ,pc.ControlName ,post.post_name FROM azrcrv_PageControls AS pc INNER JOIN azrcrv_Pages AS p ON p.ID = pc.PageNo INNER JOIN bct_posts AS post ON post.post_title = p.Name WHERE pc.ControlName = 'Document No.' ORDER BY p.ID ,pc.ControlName

Dynamics 365 BC Table ReferencePage Control Search

Pages with controls equal to DOCUMENT NO.

Seq No	Page Number	Page Name	Control Name
1	20	General Ledger Entries	Document No.
2	25	Customer Ledger Entries	Document No.
3	29	Vendor Ledger Entries	Document No.
4	38	Item Ledger Entries	Document No.
5	39	General Journal	Document No.
6	40	Item Journal	Document No.
7	46	Sales Order Subform	Document No.
8	47	Sales Invoice Subform	Document No.
9	48	Sales Orders	Document No.
10	54	Purchase Order Subform	Document No.
11	55	Purch. Invoice Subform	Document No.
12	56	Purchase Orders	Document No.
13	61	Applied Customer Entries	Document No.
14	62	Applied Vendor Entries	Document No.
15	63	Applied Employee Entries	Document No.
16	92	Job Ledger Entries	Document No.
17	93	Job Ledger Entries Preview	Document No.
18	122	G/L Entries Preview	Document No.
19	123	VAT Entries Preview	Document No.
20	126	Cust. Ledg. Entries Preview	Document No.
21	127	Det. Cust. Ledg. Entr. Preview	Document No.
22	128	Vend. Ledg. Entries Preview	Document No.
23	129	Detailed Vend. Entries Preview	Document No.
24	162	Resource Ledg. Entries Preview	Document No.
25	163	Warranty Ledg. Entries Preview	Document No.
26	165	Bank Acc. Ledg. Entr. Preview	Document No.
27	167	Item Ledger Entries Preview	Document No.
28	168	Service Ledger Entries Preview	Document No.
29	179	Reverse Entries	Document No.
30	182	Posted General Journal	Document No.
31	183	Reverse Transaction Entries	Document No.
32	186	Exch.Rate Adjmt. Ledg.Entries	Document No.
33	188	Posted Docs. With No Inc. Doc.	Document No.
34	189	Incoming Document	Document No.
35	189	Incoming Document	Document No.
36	190	Incoming Documents	Document No.
37	201	Job Journal	Document No.
38	202	Resource Ledger Entries	Document No.
39	207	Resource Journal	Document No.
40	232	Apply Customer Entries	Document No.
41	233	Apply Vendor Entries	Document No.
42	234	Apply Employee Entries	Document No.
43	253	Sales Journal	Document No.
44	254	Purchase Journal	Document No.
45	255	Cash Receipt Journal	Document No.
46	256	Payment Journal	Document No.
47	283	Recurring General Journal	Document No.
48	286	Recurring Item Jnl.	Document No.
49	289	Recurring Job Jnl.	Document No.
50	290	Recurring Resource Jnl.	Document No.
51	311	Intrastat Journal	Document No.
52	315	VAT Entries	Document No.
53	372	Bank Account Ledger Entries	Document No.
54	374	Check Ledger Entries	Document No.
55	380	Bank Acc. Reconciliation Lines	Document No.
56	381	Apply Bank Acc. Ledger Entries	Document No.
57	382	Apply Check Ledger Entries	Document No.
58	384	Bank Account Statement Lines	Document No.
59	390	Phys. Inventory Ledger Entries	Document No.
60	392	Phys. Inventory Journal	Document No.
61	393	Item Reclass. Journal	Document No.
62	404	Check Preview	Document No.
63	413	Applied Bank Acc. Ledger Entry	Document No.
64	435	Reminder Lines	Document No.
65	439	Issued Reminder Lines	Document No.
66	444	Reminder/Fin. Charge Entries	Document No.
67	447	Finance Charge Memo Lines	Document No.
68	451	Issued Fin. Charge Memo Lines	Document No.
69	499	Available – Sales Lines	Document No.
70	501	Available – Purchase Lines	Document No.
71	504	Available – Item Ledg. Entries	Document No.
72	516	Sales Lines	Document No.
73	518	Purchase Lines	Document No.
74	519	Item Journal Lines	Document No.
75	521	Application Worksheet	Document No.
76	522	View Applied Entries	Document No.
77	525	Posted Sales Shipment Lines	Document No.
78	526	Posted Sales Invoice Lines	Document No.
79	527	Posted Sales Credit Memo Lines	Document No.
80	528	Posted Purchase Receipt Lines	Document No.
81	529	Posted Purchase Invoice Lines	Document No.
82	530	Posted Purchase Cr. Memo Lines	Document No.
83	573	Detailed Cust. Ledg. Entries	Document No.
84	574	Detailed Vendor Ledg. Entries	Document No.
85	610	IC General Journal	Document No.
86	611	IC Outbox Transactions	Document No.
87	613	Handled IC Outbox Transactions	Document No.
88	615	IC Inbox Transactions	Document No.
89	617	Handled IC Inbox Transactions	Document No.
90	623	Unapply Customer Entries	Document No.
91	624	Unapply Vendor Entries	Document No.
92	625	Unapply Employee Entries	Document No.
93	658	Approval Entries	Document No.
94	659	Posted Approval Entries	Document No.
95	661	Posted Approval Comments	Document No.
96	662	Approval Request Entries	Document No.
97	666	Overdue Approval Entries	Document No.
98	741	VAT Report Subform	Document No.
99	780	Certificates of Supply	Document No.
100	841	Cash Flow Worksheet	Document No.
101	850	Cash Flow Forecast Entries	Document No.
102	863	CF Entries Dim. Matrix	Document No.
103	903	Assembly Lines	Document No.
104	926	Available – Assembly Lines	Document No.
105	958	Time Sheet Posting Entries	Document No.
106	981	Payment Registration	Document No.
107	983	Payment Registration Details	Document No.
108	1007	Job Planning Lines	Document No.
109	1008	Job WIP Entries	Document No.
110	1009	Job WIP G/L Entries	Document No.
111	1020	Job G/L Journal	Document No.
112	1029	Job Invoices	Document No.
113	1032	Available – Job Planning Lines	Document No.
114	1103	Cost Entries	Document No.
115	1108	Cost Journal	Document No.
116	1115	Cost Budget Entries	Document No.
117	1159	Purchase Documents	Document No.
118	1160	Sales Documents	Document No.
119	1161	Purchase Documents Due Today	Document No.
120	1162	Purchase Invoice Due Next Week	Document No.
121	1234	Positive Pay Export Detail	Document No.
122	1284	Outstanding Bank Transactions	Document No.
123	1292	Payment Application	Document No.
124	1571	G/L Entries Preview Subform	Document No.
125	1572	VAT Entries Preview Subform	Document No.
126	1574	G/L Entries Preview Flat Subf.	Document No.
127	1575	VAT Entries Preview Flat Subf.	Document No.
128	1600	Outlook Mail Engine	Document No.
129	1602	Office Document Selection	Document No.
130	1602	Office Document Selection	Document No.
131	1615	Office Job Journal	Document No.
132	1615	Office Job Journal	Document No.
133	1693	Bank Deposit Subform	Document No.
134	1695	Posted Bank Deposit Lines	Document No.
135	1697	Posted Bank Deposit Subform	Document No.
136	2583	Dim. Correct Ledger Entries	Document No.
137	2584	Dim Correct Posted Ledg Entr	Document No.
138	2629	Stat. Acc. Reverse Entries	Document No.
139	2633	Statistical Accounts Journal	Document No.
140	4813	Intrastat Report Subform	Document No.
141	4816	Intrastat Report Lines	Document No.
142	5073	Contact Int. Entries Subform	Document No.
143	5076	Interaction Log Entries	Document No.
144	5082	Postponed Interactions	Document No.
145	5092	Segment Subform	Document No.
146	5237	Employee Ledger Entries	Document No.
147	5238	Detailed Empl. Ledger Entries	Document No.
148	5239	Empl. Ledger Entries Preview	Document No.
149	5240	Detailed Empl. Entries Preview	Document No.
150	5510	Production Journal	Document No.
151	5530	Item Availability by Event	Document No.
152	5604	FA Ledger Entries	Document No.
153	5605	FA Error Ledger Entries	Document No.
154	5606	FA Ledger Entries Preview	Document No.
155	5628	Fixed Asset G/L Journal	Document No.
156	5629	Fixed Asset Journal	Document No.
157	5634	Recurring Fixed Asset Journal	Document No.
158	5636	FA Reclass. Journal	Document No.
159	5641	Maintenance Ledger Entries	Document No.
160	5647	Ins. Coverage Ledger Entries	Document No.
161	5651	Insurance Journal	Document No.
162	5671	Maint. Ledg. Entries Preview	Document No.
163	5708	Get Shipment Lines	Document No.
164	5709	Get Receipt Lines	Document No.
165	5749	Transfer Lines	Document No.
166	5758	Posted Transfer Shipment Lines	Document No.
167	5759	Posted Transfer Receipt Lines	Document No.
168	5802	Value Entries	Document No.
169	5803	Revaluation Journal	Document No.
170	5804	Applied Item Entries	Document No.
171	5806	Purch. Receipt Lines	Document No.
172	5807	Value Entries Preview	Document No.
173	5824	Sales Shipment Lines	Document No.
174	5832	Capacity Ledger Entries	Document No.
175	5847	Average Cost Calc. Overview	Document No.
176	5847	Average Cost Calc. Overview	Document No.
177	5851	Get Post.Doc – S.ShptLn Sbfrm	Document No.
178	5852	Get Post.Doc – S.InvLn Subform	Document No.
179	5853	Get Pst.Doc-RtrnRcptLn Subform	Document No.
180	5854	Get Post.Doc-S.Cr.MemoLn Sbfrm	Document No.
181	5856	Get Post.Doc – P.RcptLn Sbfrm	Document No.
182	5857	Get Post.Doc – P.InvLn Subform	Document No.
183	5858	Get Pst.Doc-RtrnShptLn Subform	Document No.
184	5859	Get Post.Doc-P.Cr.MemoLn Sbfrm	Document No.
185	5878	Physical Inventory Order Lines	Document No.
186	5886	Posted Phys. Invt. Order Lines	Document No.
187	5894	Posted Phys. Invt. Tracking	Document No.
188	5903	Service Item Lines	Document No.
189	5904	Service Line List	Document No.
190	5906	Service Item Worksheet	Document No.
191	5912	Service Ledger Entries	Document No.
192	5913	Warranty Ledger Entries	Document No.
193	5915	Service Tasks	Document No.
194	5920	Service Document Log	Document No.
195	5920	Service Document Log	Document No.
196	5921	Available Loaners	Document No.
197	5922	Loaner Card	Document No.
198	5923	Loaner List	Document No.
199	5924	Loaner Entries	Document No.
200	5949	Posted Serv. Shpt. Line List	Document No.
201	5951	Posted Service Invoice Lines	Document No.
202	5952	Posted Service Cr. Memo Lines	Document No.
203	5961	Service Email Queue	Document No.
204	5961	Service Email Queue	Document No.
205	5989	Service Item Log	Document No.
206	5989	Service Item Log	Document No.
207	5994	Get Service Shipment Lines	Document No.
208	5999	Available – Service Lines	Document No.
209	6001	Service Order Allocations	Document No.
210	6002	Cancelled Allocation Reasons	Document No.
211	6003	Cancelled Allocation Entries	Document No.
212	6005	Resource Allocations	Document No.
213	6022	Reallocation Entry Reasons	Document No.
214	6036	Service Lines Subform	Document No.
215	6037	Service Shipment Lines Subform	Document No.
216	6038	Service Invoice Lines Subform	Document No.
217	6039	Service Cr. Memo Lines Subform	Document No.
218	6090	FA Ledger Entries Issues	Document No.
219	6121	E-Document	Document No.
220	6121	E-Document	Document No.
221	6122	E-Documents	Document No.
222	6501	Item Tracking Entries	Document No.
223	6520	Item Tracing	Document No.
224	6619	Sales Line Archive List	Document No.
225	6626	Purchase Line Archive List	Document No.
226	6633	Sales Return Orders	Document No.
227	6638	Get Return Receipt Lines	Document No.
228	6643	Purchase Return Orders	Document No.
229	6648	Get Return Shipment Lines	Document No.
230	6653	Posted Return Shipment Lines	Document No.
231	6657	Return Shipment Lines	Document No.
232	6663	Posted Return Receipt Lines	Document No.
233	6667	Return Receipt Lines	Document No.
234	6774	Invt. Document Lines	Document No.
235	7334	Put-away Selection	Document No.
236	7343	Pick Selection	Document No.
237	9241	G/L Entries Dim. Overv. Matrix	Document No.
238	22207	Review G/L Entries	Document No.
239	30148	Shpfy Linked To Documents	Document No.
240	41006	Hist. Receivables Document	Document No.
241	41006	Hist. Receivables Document	Document No.
242	41008	Hist. Payables Document	Document No.
243	41008	Hist. Payables Document	Document No.
244	41010	Hist. Inventory Trx.	Document No.
245	41012	Hist. Inventory Trx. Headers	Document No.
246	41016	Hist. Receivables Documents	Document No.
247	41017	Hist. Payables Documents	Document No.
248	99000773	Capacity Journal	Document No.
249	99000778	Recurring Capacity Journal	Document No.
250	99000823	Output Journal	Document No.
251	99000827	Recurring Output Journal	Document No.
252	99000846	Consumption Journal	Document No.
253	99000850	Recurring Consumption Journal	Document No.

Dynamics 365 BC Table ReferencePage Control Search